USE [SUEBS]
GO

/****** Object:  View [dbo].[vwDeliveryNoteHeadList]    Script Date: 12/14/2014 19:17:18 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[vwDeliveryNoteHeadList]
AS
SELECT     dh.CCSID, dh.HeadGUID, dh.BillNo, dh.BillDate, dh.CorpCode, dh.OperType, dh.CurrCode, dh.CeCode, dh.ExchangeRate, dh.CessType, dh.ClientOrderNo, 
                      dh.ExAdddress, dh.EmsNo, dh.TransApplyNo, dh.TradeMode, dh.InvoiceNo, dh.POBillNo, dh.CompactNo, dh.SDBillNo, dh.BillStatus, dh.AudtorCode, dh.Auditor, 
                      dh.AuditingDate, dh.Remark, dh.CreateDate, dh.CreatorCode, dh.Creator, dh.LastModifyTime, dh.ModifierCode, dh.Modifier, dh.InvDate, dh.ParkingNo, dh.ParkingDate, 
                      dh.RCorpCode, dh.EntInvoiceNo, dh.EntInvDate, dh.EntParkingNo, dh.EntParkingDate, dh.PicBillStatus, ph.POType
FROM         dbo.DeliveryNoteHead AS dh INNER JOIN
                      dbo.PurOrderHead AS ph ON dh.POBillNo = ph.BillNo

GO



